#!/bin/bash

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap \
--table rpt_school_reg_cnt \
--input-fields-terminated-by '\001' \
--export-dir /user/hive/warehouse/oe_rpt/rpt_school_reg_cnt \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap \
--table rpt_subject_reg_cnt \
--input-fields-terminated-by '\001' \
--export-dir /user/hive/warehouse/oe_rpt/rpt_subject_reg_cnt \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap \
--table rpt_sub_sch_reg_cnt \
--input-fields-terminated-by '\001' \
--export-dir /user/hive/warehouse/oe_rpt/rpt_sub_sch_reg_cnt \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap \
--table rpt_consult_center_reg_cnt\
--input-fields-terminated-by '\001' \
--export-dir /user/hive/warehouse/oe_rpt/rpt_consult_center_reg_cnt \
-m 1

sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap \
--table rpt_reship_reg_cnt \
--input-fields-terminated-by '\001' \
--export-dir /user/hive/warehouse/oe_rpt/rpt_reship_reg_cnt \
-m 1


sqoop export \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/oe_olap \
--table rpt_clue_reg_cnt \
--input-fields-terminated-by '\001' \
--export-dir /user/hive/warehouse/oe_rpt/rpt_clue_reg_cnt\
-m 1